<?xml version="1.0" encoding="utf-8" ?>
<sqlMap namespace='ProcessCheckDetail' xmlns='http://ibatis.apache.org/mapping' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance'>
  <alias>
    <typeAlias alias='ProcessCheckDetail' assembly='Janus.Mes.POCO.dll' type='Janus.Mes.POCO.ProcessCheckDetail' />
  </alias>
  <resultMaps>
    <resultMap id='ProcessCheckDetailResult' class='ProcessCheckDetail'>
	<result property='Id' column='Id' /> 
	<result property='CheckPCode' column='CheckPCode' /> 
	<result property='FeatCode' column='FeatCode' /> 
	<result property='ProId' column='ProId' /> 
	<result property='DefectLCode' column='DefectLCode' /> 
	<result property='IsMustCheck' column='IsMustCheck' /> 
	<result property='IsDestroy' column='IsDestroy' /> 
	<result property='IsSize' column='IsSize' /> 
	<result property='IsReliability' column='IsReliability' /> 
	<result property='ControlData' column='ControlData' /> 
	<result property='UnitCode' column='UnitCode' /> 
	<result property='Digit' column='Digit' /> 
	<result property='StdValue' column='StdValue' /> 
	<result property='UpperValue' column='UpperValue' /> 
	<result property='LowerValue' column='LowerValue' /> 
	<result property='MaxValue' column='MaxValue' /> 
	<result property='MinValue' column='MinValue' /> 
	<result property='CheckMethod' column='CheckMethod' /> 
	<result property='CheckEqui' column='CheckEqui' /> 
	<result property='CheckAdd' column='CheckAdd' /> 
	<result property='CheckEnvi' column='CheckEnvi' /> 
	<result property='CheckMode' column='CheckMode' /> 
	<result property='Remark' column='Remark' /> 
	<result property='Creator' column='Creator' /> 
	<result property='CreateDate' column='CreateDate' /> 
	<result property='Updater' column='Updater' /> 
	<result property='UpdateDate' column='UpdateDate' /> 
	<result property='IsDelete' column='IsDelete' /> 
	<result property='CreatorCode' column='CreatorCode' /> 
	<result property='UpdaterCode' column='UpdaterCode' /> 
	<result property='OperDept' column='OperDept' /> 
	<result property='Timestamp' column='Timestamp' /> 
		</resultMap>
  </resultMaps>  
  <statements>
  <sql id="UpdaterConditions">  
  <dynamic prepend="SET">
      	<isPropertyAvailable prepend="" property="CheckPCode">
        <isNotEmpty prepend="," property="CheckPCode">
		          [CheckPCode]=#CheckPCode#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="FeatCode">
        <isNotEmpty prepend="," property="FeatCode">
		          [FeatCode]=#FeatCode#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="ProId">
        <isNotEmpty prepend="," property="ProId">
		          [ProId]=#ProId#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="DefectLCode">
        <isNotEmpty prepend="," property="DefectLCode">
		          [DefectLCode]=#DefectLCode#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="IsMustCheck">
        <isNotEmpty prepend="," property="IsMustCheck">
		          [IsMustCheck]=#IsMustCheck#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="IsDestroy">
        <isNotEmpty prepend="," property="IsDestroy">
		          [IsDestroy]=#IsDestroy#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="IsSize">
        <isNotEmpty prepend="," property="IsSize">
		          [IsSize]=#IsSize#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="IsReliability">
        <isNotEmpty prepend="" property="IsReliability">
				  <isNotEqual prepend="," property="IsReliability" compareValue="false">
		          [IsReliability]=#IsReliability#
		  		  </isNotEqual>
		        </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="ControlData">
        <isNotEmpty prepend="" property="ControlData">
				  <isNotEqual prepend="," property="ControlData" compareValue="0">
		          [ControlData]=#ControlData#
		  		  </isNotEqual>
		        </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="UnitCode">
        <isNotEmpty prepend="," property="UnitCode">
		          [UnitCode]=#UnitCode#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="Digit">
        <isNotEmpty prepend="" property="Digit">
				  <isNotEqual prepend="," property="Digit" compareValue="0">
		          [Digit]=#Digit#
		  		  </isNotEqual>
		        </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="StdValue">
        <isNotEmpty prepend="," property="StdValue">
		          [StdValue]=#StdValue#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="UpperValue">
        <isNotEmpty prepend="" property="UpperValue">
				  <isNotEqual prepend="," property="UpperValue" compareValue="0">
		          [UpperValue]=#UpperValue#
		  		  </isNotEqual>
		        </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="LowerValue">
        <isNotEmpty prepend="" property="LowerValue">
				  <isNotEqual prepend="," property="LowerValue" compareValue="0">
		          [LowerValue]=#LowerValue#
		  		  </isNotEqual>
		        </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="MaxValue">
        <isNotEmpty prepend="" property="MaxValue">
				  <isNotEqual prepend="," property="MaxValue" compareValue="0">
		          [MaxValue]=#MaxValue#
		  		  </isNotEqual>
		        </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="MinValue">
        <isNotEmpty prepend="" property="MinValue">
				  <isNotEqual prepend="," property="MinValue" compareValue="0">
		          [MinValue]=#MinValue#
		  		  </isNotEqual>
		        </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="CheckMethod">
        <isNotEmpty prepend="," property="CheckMethod">
		          [CheckMethod]=#CheckMethod#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="CheckEqui">
        <isNotEmpty prepend="," property="CheckEqui">
		          [CheckEqui]=#CheckEqui#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="CheckAdd">
        <isNotEmpty prepend="," property="CheckAdd">
		          [CheckAdd]=#CheckAdd#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="CheckEnvi">
        <isNotEmpty prepend="," property="CheckEnvi">
		          [CheckEnvi]=#CheckEnvi#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="CheckMode">
        <isNotEmpty prepend="," property="CheckMode">
		          [CheckMode]=#CheckMode#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="Remark">
        <isNotEmpty prepend="," property="Remark">
		          [Remark]=#Remark#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="Creator">
        <isNotEmpty prepend="," property="Creator">
		          [Creator]=#Creator#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="CreateDate">
        <isNotEmpty prepend="" property="CreateDate">
				  <isNotEqual prepend="," property="CreateDate" compareValue="1900-01-01">
		          [CreateDate]=#CreateDate#
		  		  </isNotEqual>
		        </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="Updater">
        <isNotEmpty prepend="," property="Updater">
		          [Updater]=#Updater#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="UpdateDate">
        <isNotEmpty prepend="" property="UpdateDate">
				  <isNotEqual prepend="," property="UpdateDate" compareValue="1900-01-01">
		          [UpdateDate]=#UpdateDate#
		  		  </isNotEqual>
		        </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="IsDelete">
        <isNotEmpty prepend="" property="IsDelete">
				  <isNotEqual prepend="," property="IsDelete" compareValue="0">
		          [IsDelete]=#IsDelete#
		  		  </isNotEqual>
		        </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="CreatorCode">
        <isNotEmpty prepend="," property="CreatorCode">
		          [CreatorCode]=#CreatorCode#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="UpdaterCode">
        <isNotEmpty prepend="," property="UpdaterCode">
		          [UpdaterCode]=#UpdaterCode#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="OperDept">
        <isNotEmpty prepend="," property="OperDept">
		          [OperDept]=#OperDept#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	 </dynamic>
    </sql>
	<sql id="WhereConditions">
	 <dynamic prepend="WHERE">
	 	 <isPropertyAvailable prepend="" property="Id">
        <isNotEmpty prepend="AND" property="Id">
		          [Id]=#Id#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="CheckPCode">
        <isNotEmpty prepend="AND" property="CheckPCode">
		          [CheckPCode]=#CheckPCode#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="FeatCode">
        <isNotEmpty prepend="AND" property="FeatCode">
		          [FeatCode]=#FeatCode#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="ProId">
        <isNotEmpty prepend="AND" property="ProId">
		          [ProId]=#ProId#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="DefectLCode">
        <isNotEmpty prepend="AND" property="DefectLCode">
		          [DefectLCode]=#DefectLCode#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="IsMustCheck">
        <isNotEmpty prepend="AND" property="IsMustCheck">
		          [IsMustCheck]=#IsMustCheck#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="IsDestroy">
        <isNotEmpty prepend="AND" property="IsDestroy">
		          [IsDestroy]=#IsDestroy#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="IsSize">
        <isNotEmpty prepend="AND" property="IsSize">
		          [IsSize]=#IsSize#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="IsReliability">
        <isNotEmpty prepend="" property="IsReliability">
				  <isNotEqual prepend="AND" property="IsReliability" compareValue="false">
		          [IsReliability]=#IsReliability#
		  		  </isNotEqual>
		        </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="ControlData">
        <isNotEmpty prepend="" property="ControlData">
				  <isNotEqual prepend="AND" property="ControlData" compareValue="0">
		          [ControlData]=#ControlData#
		  		  </isNotEqual>
		        </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="UnitCode">
        <isNotEmpty prepend="AND" property="UnitCode">
		          [UnitCode]=#UnitCode#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="Digit">
        <isNotEmpty prepend="" property="Digit">
				  <isNotEqual prepend="AND" property="Digit" compareValue="0">
		          [Digit]=#Digit#
		  		  </isNotEqual>
		        </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="StdValue">
        <isNotEmpty prepend="AND" property="StdValue">
		          [StdValue]=#StdValue#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="UpperValue">
        <isNotEmpty prepend="" property="UpperValue">
				  <isNotEqual prepend="AND" property="UpperValue" compareValue="0">
		          [UpperValue]=#UpperValue#
		  		  </isNotEqual>
		        </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="LowerValue">
        <isNotEmpty prepend="" property="LowerValue">
				  <isNotEqual prepend="AND" property="LowerValue" compareValue="0">
		          [LowerValue]=#LowerValue#
		  		  </isNotEqual>
		        </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="MaxValue">
        <isNotEmpty prepend="" property="MaxValue">
				  <isNotEqual prepend="AND" property="MaxValue" compareValue="0">
		          [MaxValue]=#MaxValue#
		  		  </isNotEqual>
		        </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="MinValue">
        <isNotEmpty prepend="" property="MinValue">
				  <isNotEqual prepend="AND" property="MinValue" compareValue="0">
		          [MinValue]=#MinValue#
		  		  </isNotEqual>
		        </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="CheckMethod">
        <isNotEmpty prepend="AND" property="CheckMethod">
		          [CheckMethod]=#CheckMethod#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="CheckEqui">
        <isNotEmpty prepend="AND" property="CheckEqui">
		          [CheckEqui]=#CheckEqui#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="CheckAdd">
        <isNotEmpty prepend="AND" property="CheckAdd">
		          [CheckAdd]=#CheckAdd#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="CheckEnvi">
        <isNotEmpty prepend="AND" property="CheckEnvi">
		          [CheckEnvi]=#CheckEnvi#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="CheckMode">
        <isNotEmpty prepend="AND" property="CheckMode">
		          [CheckMode]=#CheckMode#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="Remark">
        <isNotEmpty prepend="AND" property="Remark">
		          [Remark]=#Remark#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="Creator">
        <isNotEmpty prepend="AND" property="Creator">
		          [Creator]=#Creator#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="CreateDate">
        <isNotEmpty prepend="" property="CreateDate">
				  <isNotEqual prepend="AND" property="CreateDate" compareValue="1900-01-01">
		          [CreateDate]=#CreateDate#
		  		  </isNotEqual>
		        </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="Updater">
        <isNotEmpty prepend="AND" property="Updater">
		          [Updater]=#Updater#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="UpdateDate">
        <isNotEmpty prepend="" property="UpdateDate">
				  <isNotEqual prepend="AND" property="UpdateDate" compareValue="1900-01-01">
		          [UpdateDate]=#UpdateDate#
		  		  </isNotEqual>
		        </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="IsDelete">
        <isNotEmpty prepend="" property="IsDelete">
				  <isNotEqual prepend="AND" property="IsDelete" compareValue="0">
		          [IsDelete]=#IsDelete#
		  		  </isNotEqual>
		        </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="CreatorCode">
        <isNotEmpty prepend="AND" property="CreatorCode">
		          [CreatorCode]=#CreatorCode#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="UpdaterCode">
        <isNotEmpty prepend="AND" property="UpdaterCode">
		          [UpdaterCode]=#UpdaterCode#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="OperDept">
        <isNotEmpty prepend="AND" property="OperDept">
		          [OperDept]=#OperDept#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="Timestamp">
        <isNotEmpty prepend="" property="Timestamp">
				  <isNotEqual prepend="AND" property="Timestamp" compareValue="1900-01-01">
		          [Timestamp]=#Timestamp#
		  		  </isNotEqual>
		        </isNotEmpty>
      </isPropertyAvailable>
	  </dynamic> 
    </sql>
	<sql id="InsertPublic">
      INSERT INTO ProcessCheckDetail(
	     <dynamic prepend=" ">
       	   <isPropertyAvailable prepend="" property="Id">
        <isNotEmpty prepend="," property="Id">
          [Id]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="CheckPCode">
        <isNotEmpty prepend="," property="CheckPCode">
          [CheckPCode]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="FeatCode">
        <isNotEmpty prepend="," property="FeatCode">
          [FeatCode]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="ProId">
        <isNotEmpty prepend="," property="ProId">
          [ProId]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="DefectLCode">
        <isNotEmpty prepend="," property="DefectLCode">
          [DefectLCode]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="IsMustCheck">
        <isNotEmpty prepend="," property="IsMustCheck">
          [IsMustCheck]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="IsDestroy">
        <isNotEmpty prepend="," property="IsDestroy">
          [IsDestroy]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="IsSize">
        <isNotEmpty prepend="," property="IsSize">
          [IsSize]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="IsReliability">
        <isNotEmpty prepend="," property="IsReliability">
          [IsReliability]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="ControlData">
        <isNotEmpty prepend="," property="ControlData">
          [ControlData]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="UnitCode">
        <isNotEmpty prepend="," property="UnitCode">
          [UnitCode]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="Digit">
        <isNotEmpty prepend="," property="Digit">
          [Digit]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="StdValue">
        <isNotEmpty prepend="," property="StdValue">
          [StdValue]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="UpperValue">
        <isNotEmpty prepend="," property="UpperValue">
          [UpperValue]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="LowerValue">
        <isNotEmpty prepend="," property="LowerValue">
          [LowerValue]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="MaxValue">
        <isNotEmpty prepend="," property="MaxValue">
          [MaxValue]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="MinValue">
        <isNotEmpty prepend="," property="MinValue">
          [MinValue]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="CheckMethod">
        <isNotEmpty prepend="," property="CheckMethod">
          [CheckMethod]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="CheckEqui">
        <isNotEmpty prepend="," property="CheckEqui">
          [CheckEqui]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="CheckAdd">
        <isNotEmpty prepend="," property="CheckAdd">
          [CheckAdd]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="CheckEnvi">
        <isNotEmpty prepend="," property="CheckEnvi">
          [CheckEnvi]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="CheckMode">
        <isNotEmpty prepend="," property="CheckMode">
          [CheckMode]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="Remark">
        <isNotEmpty prepend="," property="Remark">
          [Remark]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="Creator">
        <isNotEmpty prepend="," property="Creator">
          [Creator]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="CreateDate">
        <isNotEmpty prepend="," property="CreateDate">
          [CreateDate]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="Updater">
        <isNotEmpty prepend="," property="Updater">
          [Updater]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="UpdateDate">
        <isNotEmpty prepend="," property="UpdateDate">
          [UpdateDate]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="IsDelete">
        <isNotEmpty prepend="," property="IsDelete">
          [IsDelete]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="CreatorCode">
        <isNotEmpty prepend="," property="CreatorCode">
          [CreatorCode]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="UpdaterCode">
        <isNotEmpty prepend="," property="UpdaterCode">
          [UpdaterCode]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="OperDept">
        <isNotEmpty prepend="," property="OperDept">
          [OperDept]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="Timestamp">
        <isNotEmpty prepend="," property="Timestamp">
          [Timestamp]
        </isNotEmpty>
      </isPropertyAvailable>
	  </dynamic>
      )
      VALUES
      (
	   <dynamic prepend=" ">
      	<isPropertyAvailable prepend="" property="Id">
        <isNotEmpty prepend="," property="Id">		
         #Id#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="CheckPCode">
        <isNotEmpty prepend="," property="CheckPCode">		
         #CheckPCode#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="FeatCode">
        <isNotEmpty prepend="," property="FeatCode">		
         #FeatCode#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="ProId">
        <isNotEmpty prepend="," property="ProId">		
         #ProId#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="DefectLCode">
        <isNotEmpty prepend="," property="DefectLCode">		
         #DefectLCode#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="IsMustCheck">
        <isNotEmpty prepend="," property="IsMustCheck">		
         #IsMustCheck#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="IsDestroy">
        <isNotEmpty prepend="," property="IsDestroy">		
         #IsDestroy#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="IsSize">
        <isNotEmpty prepend="," property="IsSize">		
         #IsSize#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="IsReliability">
        <isNotEmpty prepend="," property="IsReliability">		
         #IsReliability#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="ControlData">
        <isNotEmpty prepend="," property="ControlData">		
         #ControlData#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="UnitCode">
        <isNotEmpty prepend="," property="UnitCode">		
         #UnitCode#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="Digit">
        <isNotEmpty prepend="," property="Digit">		
         #Digit#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="StdValue">
        <isNotEmpty prepend="," property="StdValue">		
         #StdValue#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="UpperValue">
        <isNotEmpty prepend="," property="UpperValue">		
         #UpperValue#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="LowerValue">
        <isNotEmpty prepend="," property="LowerValue">		
         #LowerValue#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="MaxValue">
        <isNotEmpty prepend="," property="MaxValue">		
         #MaxValue#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="MinValue">
        <isNotEmpty prepend="," property="MinValue">		
         #MinValue#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="CheckMethod">
        <isNotEmpty prepend="," property="CheckMethod">		
         #CheckMethod#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="CheckEqui">
        <isNotEmpty prepend="," property="CheckEqui">		
         #CheckEqui#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="CheckAdd">
        <isNotEmpty prepend="," property="CheckAdd">		
         #CheckAdd#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="CheckEnvi">
        <isNotEmpty prepend="," property="CheckEnvi">		
         #CheckEnvi#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="CheckMode">
        <isNotEmpty prepend="," property="CheckMode">		
         #CheckMode#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="Remark">
        <isNotEmpty prepend="," property="Remark">		
         #Remark#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="Creator">
        <isNotEmpty prepend="," property="Creator">		
         #Creator#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="CreateDate">
        <isNotEmpty prepend="," property="CreateDate">		
         #CreateDate#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="Updater">
        <isNotEmpty prepend="," property="Updater">		
         #Updater#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="UpdateDate">
        <isNotEmpty prepend="," property="UpdateDate">		
         #UpdateDate#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="IsDelete">
        <isNotEmpty prepend="," property="IsDelete">		
         #IsDelete#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="CreatorCode">
        <isNotEmpty prepend="," property="CreatorCode">		
         #CreatorCode#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="UpdaterCode">
        <isNotEmpty prepend="," property="UpdaterCode">		
         #UpdaterCode#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="OperDept">
        <isNotEmpty prepend="," property="OperDept">		
         #OperDept#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="Timestamp">
        <isNotEmpty prepend="," property="Timestamp">		
         #Timestamp#		
        </isNotEmpty>
      </isPropertyAvailable>
	  </dynamic>
      )
    </sql>
	<!-- Insert statement:新增Mapper-->
    <insert id='Insert' parameterClass='ProcessCheckDetail'>
      <include refid="InsertPublic"/>
    </insert>
    <!--Update statement:修改Mapper-->
    <update id='Update' parameterClass='ProcessCheckDetail'>
      UPDATE [ProcessCheckDetail] 
      <include refid="UpdaterConditions"/>
      WHERE 1=1
	  	  AND Id=#Id#
	      </update>
    <update id='UpdateSetion' parameterClass='hashtable'>
      UPDATE [ProcessCheckDetail] 
      <include refid="UpdaterConditions"/>
      WHERE $conditions$
    </update>
	<update id='Save' parameterClass='ProcessCheckDetail'>
      IF NOT EXISTS(SELECT 1 FROM [ProcessCheckDetail] WHERE 1=1  AND [Id]=#Id# )
      BEGIN
      <include refid="InsertPublic"/>
      END
      ELSE
      BEGIN
      UPDATE ProcessCheckDetail 
      <include refid="UpdaterConditions"/>
      WHERE  1=1
	  	  AND [Id]=#Id#
	        END
    </update>
	<delete id='Delete' parameterClass='hashtable'>
      DELETE FROM [ProcessCheckDetail] WHERE	  
        <![CDATA[  
	 [Id]=#pk0# 
        ]]>
    </delete>
    <delete id='DeleteWhere' parameterClass='string'>
      DELETE FROM [ProcessCheckDetail] WHERE $value$
    </delete>

    <!-- select by key statement:-->
    <select id='FindOne' parameterClass='hashtable' resultClass='ProcessCheckDetail'>
      SELECT * FROM ProcessCheckDetail WHERE      
        <![CDATA[
		[Id]=#pk0# 
        ]]>
    </select>
    <select id='FindAllCondition' parameterClass='string' resultClass='ProcessCheckDetail'>
      SELECT * FROM [ProcessCheckDetail] WHERE $value$
    </select>
    <select id='FindScalar' parameterClass='hashtable' resultClass='ProcessCheckDetail'>
      SELECT * FROM [ProcessCheckDetail] WHERE $conditions$
    </select>
    
    <select id='FindAllCount' parameterClass='string' resultClass='int'>
      SELECT COUNT(1) FROM [ProcessCheckDetail] WHERE $value$
    </select>
    <select id='FindByPage' parameterClass='string' resultClass='ProcessCheckDetail'>
      SELECT * FROM [ProcessCheckDetail] WHERE $value$
    </select>
  </statements>
</sqlMap>
